package soft.mapper;


import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;
import soft.pojo.Grade;

import java.util.List;
import java.util.Map;

@Mapper
@Repository
public interface GradeMapper {
	List<Grade> getList();
	Grade getByIdAndCourseName(@Param("sId") String sId, @Param("courseName") String courseName);
	boolean update(Grade bean);
	boolean addGrade(Grade bean);
	boolean deleteGrade(String sId);
	List<Map> selectGradeBycourseName();
	List<Map> selectAvgGrade();
	List<Grade> getLikeName(String sName);
	List<Grade> getById(String sId);
}
